Structured Spreadsheet Modelling and Implementation: A Methodology for Creating Effective Spreadsheets by Paul Mireault

Structured Spreadsheet Modelling and Implementation: A Methodology for Creating Effective Spreadsheets by Paul Mireault

Author:Paul Mireault [Mireault, Paul]
Language: eng
Format: azw3
Publisher: SSMI International
Published: 2017-03-20T04:00:00+00:00


Figure 7‑2 Inventory Model, Three Months

This is the same problem you saw when you introduced the repeating sub-model: this structure does not scale well. A 12-month, 24-month or 60-month model would become impractically large and unwieldy. You would like to be able to identify a group of repeating variables and formulas with the same suffix, so that you can build a repeating group (as you did earlier in Chapter 5). However, the formula that calculates the end-of-month inventory uses variables with two different suffixes.

The key to simplifying the model is to create a new calculated variable for each time instance, which acts as an intermediary between one period and the next. Consider the model presented in Figure 7‑3.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.